
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[PerferencesSet]
    @UserId INT ,
    @Name VARBINARY(MAX) ,
    @Value VARBINARY(MAX)
AS 
    BEGIN
        UPDATE  Perferences
        SET     Value = @Value
        WHERE   Name = @Name
                AND UserId = @UserId
    END
GO
